create database Blogs
go
use Blogs
go
create table Users
(
Id int primary key identity,
Username nvarchar(6) not null,
Password nvarchar(80) not null 
)
create table Articles
(
Id int primary key identity,
Title nvarchar(10) not null,
Author nvarchar(10) not null,
CreatedTime datetime default getdate()
)
insert into Users(Username,Password)values('YanYan','123456')
insert into Articles(Title,Author)values
('《若爱只是擦肩而过》','秋夜雨寒','2020.07.04'),
('《微微一笑很倾城》','顾漫','2020.07.04'),
('《何以笙箫默》','顾漫','2020.07.04'),
('《摄政王的冷妃》','过路人与稻草人','2020.07.04'),
('《我的妖孽大哥》','夜紫雨','2020.07.04'),
('《且试天下》','倾泠月','2020.07.04'),
('《盗情》','周玉','2020.07.04'),
('《傲风》','风行烈','2020.07.04')

select * from Users
select * from Articles